USE [OctoNetApps]
GO

/****** Object:  StoredProcedure [classified].[ClassifiedAds_SetStatus]    Script Date: 05/25/2011 06:58:22 ******/
SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO



CREATE PROCEDURE [classified].[ClassifiedAds_SetStatus]
	@ResourceID bigint,
	@AdID bigint,
	@AdStatus tinyint,
	@Description varchar(300)
AS
BEGIN

	SET NOCOUNT ON;
	
		UPDATE classified.ClassifiedAds
		SET [Status] = @AdStatus, [Description] = @Description WHERE ResourceID = @ResourceID AND AdID = @AdID

END






GO


